CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_app_user_service_site_mapping(
id                                                 bigint                         COMMENT '',
version                                            Double                         COMMENT '',
createtime                                         String                         COMMENT '',
lastupdatetime                                     String                         COMMENT '',
appUserId                                          String                         COMMENT '',
spCode                                             String                         COMMENT '',
spName                                             String                         COMMENT '',
serviceSiteCode                                    String                         COMMENT '',
serviceSiteName                                    String                         COMMENT '',
userId                                             Double                         COMMENT '',
username                                           String                         COMMENT '',
status                                             bigint                         COMMENT ''
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_app_user_service_site_mapping'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);